Connected to Snowflake.
Customer: KIVA
Schema: KIVA_PROD.OPTIML
2023-02-03 2023-02-11

Total cost breakdown¶

Cost by usage category¶

Category: Credit and dollar consumption trends
----------------------------------------------
category_name      credits_previous_week    dollars_previous_week    credits    dollars    pct_change_dollars
---------------  -----------------------  -----------------------  ---------  ---------  --------------------
Cloud services                     56.65                   113.3       43.71      87.42                -22.84
Compute                           781.95                  1563.91     768.67    1537.34                 -1.7
Storage                             0                       55.71       0         60.96                  9.42
Total                             838.6                   1732.91     812.38    1685.72                 -2.72

Cost by user¶

Users: Credit consumption trends
--------------------------------
user_name                 approximate_credits_previous_week    approximate_credits    pct_change_credits
----------------------  -----------------------------------  ---------------------  --------------------
AMPLITUDE                                              0.17                   0.27                 58.82
DBT_DEV                                               74.13                  72.58                 -2.09
DBT_PROD                                             127.9                  127.37                 -0.41
FIVETRAN_USER                                        360.25                 339.12                 -5.87
FIVETRAN_USER_DEV                                     54.5                   54.72                  0.4
GREGORYW                                               0.94                   1.19                 26.6
GREGORYW_DEV                                           0.33                   0.17                -48.48
LOOKER_DEV_ADMIN                                       3.6                    3.51                 -2.5
LOOKER_PROD                                           34.19                  34.38                  0.56
LOOKER_PROD_ADMIN                                     17.15                  18.57                  8.28
LOOKER_RAW_DEV                                         0.49                   0.37                -24.49
LOOKER_RAW_PROD                                        3.97                   4.05                  2.02
MAXH_DEV                                               0.02                   0.01                -50
ML_SERVICE_DEV                                        57.48                  56.63                 -1.48
ML_SERVICE_PROD                                       44.63                  44.79                  0.36
ROBS                                                   0.41                   0                  -100
VERTEX_API_DEV                                         1.94                   1.31                -32.47
VERTEX_API_DEV_JENKINS                                 0.84                   0.39                -53.57
VERTEX_API_PROD                                       55.67                  52.62                 -5.48
JAY                                                    0                      0.01                inf
OPTIML                                                 0                      0.3                 inf
Total                                                838.61                 812.36                 -3.13
List of low usage users (<1% of credits) with usage (Current month)
-------------------------------------------------------------------
user_name                 approximate_credits    percent_usage
----------------------  ---------------------  ---------------
AMPLITUDE                                0.27            0.033
GREGORYW                                 1.19            0.146
GREGORYW_DEV                             0.17            0.021
LOOKER_DEV_ADMIN                         3.51            0.432
LOOKER_RAW_DEV                           0.37            0.046
LOOKER_RAW_PROD                          4.05            0.499
MAXH_DEV                                 0.01            0.001
ROBS                                     0               0
VERTEX_API_DEV                           1.31            0.161
VERTEX_API_DEV_JENKINS                   0.39            0.048
JAY                                      0.01            0.001
OPTIML                                   0.3             0.037

Cost by warehouse¶

Warehouses: Credit consumption trends
-------------------------------------
warehouse_name         credits_previous_week    credits    pct_change_credits
-------------------  -----------------------  ---------  --------------------
DEV_WH                                194.63     190.98                 -1.88
ML_WH                                  35.25      35.59                  0.96
PROD_AUX_WH                            66.76      67.84                  1.62
PROD_WH                               541.96     517.97                 -4.43
CLOUD_SERVICES_ONLY                     0          0                     0
Total                                 812.38     838.6                   3.23

Cost by Partner Tools¶

Client Application: Credit consumption trends
---------------------------------------------
client_application_name      approximate_credits_previous_week    approximate_credits    pct_change_credits
-------------------------  -----------------------------------  ---------------------  --------------------
Go                                                        0.95                   1.2                  26.32
JDBC                                                    474.73                 454.98                 -4.16
ODBC                                                     58.44                  54.33                 -7.03
Python                                                  304.46                 301.86                 -0.85
Snowflake UI                                              0.02                   0.02                  0
Total                                                   838.6                  812.39                 -3.13

Further Possible Actions on this notebook¶

  • Cost by tasks if that exists - doesnt seem to for Kiva - would like to understand this usage pattern
  • Cost by partner tools takes ~3 min for each run for 1 week. Needs to run twice during an analysis. Does this require mitigation? All other queries run in a few sec. each.
  • Provide recommendation for total resource monitor - weekly
  • Provide recommendation for resource monitor by day of the week:
    • Warehouse
    • User
    • Client application
  • Next set of notebooks